package com.seraph.zys.dao.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.stereotype.Repository;

import com.seraph.bi.suite.support.domain.pagination.PageBox;
import com.seraph.bi.suite.support.domain.pagination.PageObject;
import com.seraph.bi.suite.support.security.BaseUser;
import com.seraph.bi.suite.support.security.LoginUtil;
import com.seraph.zys.dao.ViewAllWorkflowInfoDAO;
import com.seraph.zys.dao.domain.ViewAllWorkflowInfo;
import com.seraph.zys.dao.domain.ViewAllWorkflowInfoExample;
import com.seraph.zys.dao.domain.ViewAllWorkflowInfoWithBLOBs;

@Repository
public class ViewAllWorkflowInfoDAOImpl extends SqlMapClientDaoSupport implements ViewAllWorkflowInfoDAO {

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public ViewAllWorkflowInfoDAOImpl() {
        super();
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public void insert(ViewAllWorkflowInfoWithBLOBs record) {
        getSqlMapClientTemplate().insert("view_all_workflow_info.abatorgenerated_insert", record);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public List selectByExampleWithoutBLOBs(ViewAllWorkflowInfoExample example, String orderByClause) {
    	example.setOrgCode_Indicator(ViewAllWorkflowInfoExample.EXAMPLE_EQUALS); 
        BaseUser user = (BaseUser) LoginUtil.getUser();
        String org_Code=user.getOrgCode();
        String orgCode=example.getOrgCode();
        if(orgCode==null||"".equals(orgCode)){
        	example.setOrgCode(org_Code);
        }     	
        Map parms = getExampleParms(example);
        parms.put("AND_ORG_CODE_WITH_SECURITY", "Y"); 
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        List list = getSqlMapClientTemplate().queryForList("view_all_workflow_info.abatorgenerated_selectByExample", parms);
        return list;
    }

    public ViewAllWorkflowInfoWithBLOBs selectByPrimaryKey(String activityNo) {
    	ViewAllWorkflowInfo key = new ViewAllWorkflowInfo();
        key.setActivityNo(activityNo);
        ViewAllWorkflowInfoWithBLOBs record = (ViewAllWorkflowInfoWithBLOBs) getSqlMapClientTemplate().queryForObject("view_all_workflow_info.abatorgenerated_selectByPrimaryKey", key);
        return record;
    }    
    
    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public List selectByExampleWithoutBLOBs(ViewAllWorkflowInfoExample example) {
        return selectByExampleWithoutBLOBs(example, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public List selectByExampleWithBLOBs(ViewAllWorkflowInfoExample example, String orderByClause) {
    	example.setOrgCode_Indicator(ViewAllWorkflowInfoExample.EXAMPLE_EQUALS); 
        BaseUser user = (BaseUser) LoginUtil.getUser();
        String org_Code=user.getOrgCode();
        String orgCode=example.getOrgCode();
        if(orgCode==null||"".equals(orgCode)){
        	example.setOrgCode(org_Code);
        }     	
        Map parms = getExampleParms(example);
        parms.put("AND_ORG_CODE_WITH_SECURITY", "Y"); 
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        List list = getSqlMapClientTemplate().queryForList("view_all_workflow_info.abatorgenerated_selectByExampleWithBLOBs", parms);
        return list;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public List selectByExampleWithBLOBs(ViewAllWorkflowInfoExample example) {
        return selectByExampleWithBLOBs(example, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public int deleteByExample(ViewAllWorkflowInfoExample example) {
        int rows = getSqlMapClientTemplate().delete("view_all_workflow_info.abatorgenerated_deleteByExample", getExampleParms(example));
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getORG_CODEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getOrgCode_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_NULL", "Y");
            } else {
                parms.put("AND_ORG_CODE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ORG_CODE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_EQUALS", "Y");
            } else {
                parms.put("AND_ORG_CODE_EQUALS", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ORG_CODE_NOT_EQUALS", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_GT", "Y");
            } else {
                parms.put("AND_ORG_CODE_GT", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_GE", "Y");
            } else {
                parms.put("AND_ORG_CODE_GE", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_LT", "Y");
            } else {
                parms.put("AND_ORG_CODE_LT", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_LE", "Y");
            } else {
                parms.put("AND_ORG_CODE_LE", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ORG_CODE_LIKE", "Y");
            } else {
                parms.put("AND_ORG_CODE_LIKE", "Y");
            }
            parms.put("orgCode", example.getOrgCode());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getMANAGERExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getManager_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_NULL", "Y");
            } else {
                parms.put("AND_MANAGER_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_NOT_NULL", "Y");
            } else {
                parms.put("AND_MANAGER_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGER_EQUALS", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGER_NOT_EQUALS", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_GT", "Y");
            } else {
                parms.put("AND_MANAGER_GT", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_GE", "Y");
            } else {
                parms.put("AND_MANAGER_GE", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_LT", "Y");
            } else {
                parms.put("AND_MANAGER_LT", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_LE", "Y");
            } else {
                parms.put("AND_MANAGER_LE", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGER_LIKE", "Y");
            } else {
                parms.put("AND_MANAGER_LIKE", "Y");
            }
            parms.put("manager", example.getManager());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getPLAN_TYPEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getPlanType_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_NULL", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_NOT_NULL", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_EQUALS", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_EQUALS", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_NOT_EQUALS", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_GT", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_GT", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_GE", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_GE", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_LT", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_LT", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_LE", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_LE", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PLAN_TYPE_LIKE", "Y");
            } else {
                parms.put("AND_PLAN_TYPE_LIKE", "Y");
            }
            parms.put("planType", example.getPlanType());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getFISCAL_YEARExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getFiscalYear_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getFUNDS_FROMExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getFundsFrom_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_NULL", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_NOT_NULL", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_EQUALS", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_EQUALS", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_NOT_EQUALS", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_GT", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_GT", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_GE", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_GE", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_LT", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_LT", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_LE", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_LE", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FROM_LIKE", "Y");
            } else {
                parms.put("AND_FUNDS_FROM_LIKE", "Y");
            }
            parms.put("fundsFrom", example.getFundsFrom());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getFUNDS_FIELDExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getFundsField_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_NULL", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_NOT_NULL", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_EQUALS", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_EQUALS", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_NOT_EQUALS", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_GT", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_GT", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_GE", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_GE", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_LT", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_LT", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_LE", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_LE", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FUNDS_FIELD_LIKE", "Y");
            } else {
                parms.put("AND_FUNDS_FIELD_LIKE", "Y");
            }
            parms.put("fundsField", example.getFundsField());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getACTIVITY_NAMEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getActivityName_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_NOT_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_EQUALS", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_NOT_EQUALS", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_GT", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_GT", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_GE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_GE", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_LT", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_LT", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_LE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_LE", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NAME_LIKE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NAME_LIKE", "Y");
            }
            parms.put("activityName", example.getActivityName());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getACTIVITY_LOCATIONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getActivityLocation_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_NOT_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_EQUALS", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_NOT_EQUALS", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_GT", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_GT", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_GE", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_GE", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_LT", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_LT", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_LE", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_LE", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_LOCATION_LIKE", "Y");
            } else {
                parms.put("AND_ACTIVITY_LOCATION_LIKE", "Y");
            }
            parms.put("activityLocation", example.getActivityLocation());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getBUDGETExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getBudget_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_NULL", "Y");
            } else {
                parms.put("AND_BUDGET_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_NOT_NULL", "Y");
            } else {
                parms.put("AND_BUDGET_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_EQUALS", "Y");
            } else {
                parms.put("AND_BUDGET_EQUALS", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_BUDGET_NOT_EQUALS", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_GT", "Y");
            } else {
                parms.put("AND_BUDGET_GT", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_GE", "Y");
            } else {
                parms.put("AND_BUDGET_GE", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_LT", "Y");
            } else {
                parms.put("AND_BUDGET_LT", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_BUDGET_LE", "Y");
            } else {
                parms.put("AND_BUDGET_LE", "Y");
            }
            parms.put("budget", example.getBudget());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIDExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getId_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NULL", "Y");
            } else {
                parms.put("AND_ID_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_NULL", "Y");
            } else {
                parms.put("AND_ID_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_EQUALS", "Y");
            } else {
                parms.put("AND_ID_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ID_NOT_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GT", "Y");
            } else {
                parms.put("AND_ID_GT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GE", "Y");
            } else {
                parms.put("AND_ID_GE", "Y");
            }
            parms.put("id", example.getId());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LT", "Y");
            } else {
                parms.put("AND_ID_LT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LE", "Y");
            } else {
                parms.put("AND_ID_LE", "Y");
            }
            parms.put("id", example.getId());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getACTIVITY_NOExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getActivityNo_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_NOT_NULL", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_EQUALS", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_NOT_EQUALS", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_GT", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_GT", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_GE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_GE", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_LT", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_LT", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_LE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_LE", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ACTIVITY_NO_LIKE", "Y");
            } else {
                parms.put("AND_ACTIVITY_NO_LIKE", "Y");
            }
            parms.put("activityNo", example.getActivityNo());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_SUBMIT_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskSubmitDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_EQUALS", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_GT", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_GE", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_LT", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_SUBMIT_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_SUBMIT_DATE_LE", "Y");
            }
            parms.put("askSubmitDate", example.getAskSubmitDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_START_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskStartDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_EQUALS", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_GT", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_GE", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_LT", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_START_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_START_DATE_LE", "Y");
            }
            parms.put("askStartDate", example.getAskStartDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_END_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskEndDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_EQUALS", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_GT", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_GE", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_LT", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_END_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_END_DATE_LE", "Y");
            }
            parms.put("askEndDate", example.getAskEndDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_ADDRExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskAddr_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_NULL", "Y");
            } else {
                parms.put("AND_ASK_ADDR_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_ADDR_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ADDR_EQUALS", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ADDR_NOT_EQUALS", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_GT", "Y");
            } else {
                parms.put("AND_ASK_ADDR_GT", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_GE", "Y");
            } else {
                parms.put("AND_ASK_ADDR_GE", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_LT", "Y");
            } else {
                parms.put("AND_ASK_ADDR_LT", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_LE", "Y");
            } else {
                parms.put("AND_ASK_ADDR_LE", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ADDR_LIKE", "Y");
            } else {
                parms.put("AND_ASK_ADDR_LIKE", "Y");
            }
            parms.put("askAddr", example.getAskAddr());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_BUDGETExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskBudget_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_NULL", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_EQUALS", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_NOT_EQUALS", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_GT", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_GT", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_GE", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_GE", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_LT", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_LT", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_BUDGET_LE", "Y");
            } else {
                parms.put("AND_ASK_BUDGET_LE", "Y");
            }
            parms.put("askBudget", example.getAskBudget());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_RESULTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskResult_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_NULL", "Y");
            } else {
                parms.put("AND_ASK_RESULT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_RESULT_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_RESULT_EQUALS", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_RESULT_NOT_EQUALS", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_GT", "Y");
            } else {
                parms.put("AND_ASK_RESULT_GT", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_GE", "Y");
            } else {
                parms.put("AND_ASK_RESULT_GE", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_LT", "Y");
            } else {
                parms.put("AND_ASK_RESULT_LT", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_LE", "Y");
            } else {
                parms.put("AND_ASK_RESULT_LE", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_RESULT_LIKE", "Y");
            } else {
                parms.put("AND_ASK_RESULT_LIKE", "Y");
            }
            parms.put("askResult", example.getAskResult());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_ROLLBACK_COUNTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskRollbackCount_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_NULL", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_EQUALS", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_NOT_EQUALS", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_GT", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_GT", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_GE", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_GE", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_LT", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_LT", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_COUNT_LE", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_COUNT_LE", "Y");
            }
            parms.put("askRollbackCount", example.getAskRollbackCount());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_ROLLBACK_REASONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskRollbackReason_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_NULL", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_EQUALS", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_NOT_EQUALS", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_GT", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_GT", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_GE", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_GE", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_LT", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_LT", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_LE", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_LE", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ROLLBACK_REASON_LIKE", "Y");
            } else {
                parms.put("AND_ASK_ROLLBACK_REASON_LIKE", "Y");
            }
            parms.put("askRollbackReason", example.getAskRollbackReason());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_LEADEREIM_ISSUING_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskLeadereimIssuingDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_EQUALS", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_GT", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_GE", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_LT", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_LEADEREIM_ISSUING_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_LEADEREIM_ISSUING_DATE_LE", "Y");
            }
            parms.put("askLeadereimIssuingDate", example.getAskLeadereimIssuingDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_ISTRAVELExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskIstravel_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_NULL", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_EQUALS", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_NOT_EQUALS", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_GT", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_GT", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_GE", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_GE", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_LT", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_LT", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_LE", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_LE", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_ISTRAVEL_LIKE", "Y");
            } else {
                parms.put("AND_ASK_ISTRAVEL_LIKE", "Y");
            }
            parms.put("askIstravel", example.getAskIstravel());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_TRAVEL_SEND_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskTravelSendDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_EQUALS", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_GT", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_GE", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_LT", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_SEND_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_SEND_DATE_LE", "Y");
            }
            parms.put("askTravelSendDate", example.getAskTravelSendDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getASK_TRAVEL_ISSUING_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getAskTravelIssuingDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_NULL", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_EQUALS", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_NOT_EQUALS", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_GT", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_GT", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_GE", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_GE", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_LT", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_LT", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ASK_TRAVEL_ISSUING_DATE_LE", "Y");
            } else {
                parms.put("AND_ASK_TRAVEL_ISSUING_DATE_LE", "Y");
            }
            parms.put("askTravelIssuingDate", example.getAskTravelIssuingDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_ISPOSTINGExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendIsposting_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_NULL", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_EQUALS", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_NOT_EQUALS", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_GT", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_GT", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_GE", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_GE", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_LT", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_LT", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_LE", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_LE", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ISPOSTING_LIKE", "Y");
            } else {
                parms.put("AND_SEND_ISPOSTING_LIKE", "Y");
            }
            parms.put("sendIsposting", example.getSendIsposting());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_FILE_NAMEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendFileName_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_EQUALS", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_NOT_EQUALS", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_GT", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_GT", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_GE", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_GE", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_LT", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_LT", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_LE", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_LE", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_NAME_LIKE", "Y");
            } else {
                parms.put("AND_SEND_FILE_NAME_LIKE", "Y");
            }
            parms.put("sendFileName", example.getSendFileName());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_FILE_TYPEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendFileType_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_EQUALS", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_NOT_EQUALS", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_GT", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_GT", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_GE", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_GE", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_LT", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_LT", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_LE", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_LE", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_TYPE_LIKE", "Y");
            } else {
                parms.put("AND_SEND_FILE_TYPE_LIKE", "Y");
            }
            parms.put("sendFileType", example.getSendFileType());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_FILE_SEQExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendFileSeq_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_EQUALS", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_NOT_EQUALS", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_GT", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_GT", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_GE", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_GE", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_LT", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_LT", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_LE", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_LE", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_FILE_SEQ_LIKE", "Y");
            } else {
                parms.put("AND_SEND_FILE_SEQ_LIKE", "Y");
            }
            parms.put("sendFileSeq", example.getSendFileSeq());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_SEND_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendSendDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_NULL", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_EQUALS", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_NOT_EQUALS", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_GT", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_GT", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_GE", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_GE", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_LT", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_LT", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_SEND_DATE_LE", "Y");
            } else {
                parms.put("AND_SEND_SEND_DATE_LE", "Y");
            }
            parms.put("sendSendDate", example.getSendSendDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_RESULTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendResult_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_NULL", "Y");
            } else {
                parms.put("AND_SEND_RESULT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_RESULT_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_RESULT_EQUALS", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_RESULT_NOT_EQUALS", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_GT", "Y");
            } else {
                parms.put("AND_SEND_RESULT_GT", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_GE", "Y");
            } else {
                parms.put("AND_SEND_RESULT_GE", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_LT", "Y");
            } else {
                parms.put("AND_SEND_RESULT_LT", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_LE", "Y");
            } else {
                parms.put("AND_SEND_RESULT_LE", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_RESULT_LIKE", "Y");
            } else {
                parms.put("AND_SEND_RESULT_LIKE", "Y");
            }
            parms.put("sendResult", example.getSendResult());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_ROLLBACK_COUNTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendRollbackCount_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_NULL", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_EQUALS", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_NOT_EQUALS", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_GT", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_GT", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_GE", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_GE", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_LT", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_LT", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_COUNT_LE", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_COUNT_LE", "Y");
            }
            parms.put("sendRollbackCount", example.getSendRollbackCount());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_ROLLBACK_REASONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendRollbackReason_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_NULL", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_EQUALS", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_NOT_EQUALS", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_GT", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_GT", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_GE", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_GE", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_LT", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_LT", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_LE", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_LE", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_ROLLBACK_REASON_LIKE", "Y");
            } else {
                parms.put("AND_SEND_ROLLBACK_REASON_LIKE", "Y");
            }
            parms.put("sendRollbackReason", example.getSendRollbackReason());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getSEND_LEADEREIM_ISSUING_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getSendLeadereimIssuingDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_NULL", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_EQUALS", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_NOT_EQUALS", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_GT", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_GT", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_GE", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_GE", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_LT", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_LT", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SEND_LEADEREIM_ISSUING_DATE_LE", "Y");
            } else {
                parms.put("AND_SEND_LEADEREIM_ISSUING_DATE_LE", "Y");
            }
            parms.put("sendLeadereimIssuingDate", example.getSendLeadereimIssuingDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_START_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplStartDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_NULL", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_EQUALS", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_NOT_EQUALS", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_GT", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_GT", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_GE", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_GE", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_LT", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_LT", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_START_DATE_LE", "Y");
            } else {
                parms.put("AND_IMPL_START_DATE_LE", "Y");
            }
            parms.put("implStartDate", example.getImplStartDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_END_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplEndDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_NULL", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_EQUALS", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_NOT_EQUALS", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_GT", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_GT", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_GE", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_GE", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_LT", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_LT", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_END_DATE_LE", "Y");
            } else {
                parms.put("AND_IMPL_END_DATE_LE", "Y");
            }
            parms.put("implEndDate", example.getImplEndDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_TIMECHANGE_REASONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplTimechangeReason_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_NULL", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_EQUALS", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_NOT_EQUALS", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_GT", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_GT", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_GE", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_GE", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_LT", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_LT", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_LE", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_LE", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_TIMECHANGE_REASON_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_TIMECHANGE_REASON_LIKE", "Y");
            }
            parms.put("implTimechangeReason", example.getImplTimechangeReason());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_ADDRExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplAddr_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_EQUALS", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_NOT_EQUALS", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_GT", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_GT", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_GE", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_GE", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_LT", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_LT", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_LE", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_LE", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDR_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_ADDR_LIKE", "Y");
            }
            parms.put("implAddr", example.getImplAddr());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_ADDRCHANGE_REASONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplAddrchangeReason_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_EQUALS", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_NOT_EQUALS", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_GT", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_GT", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_GE", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_GE", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_LT", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_LT", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_LE", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_LE", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ADDRCHANGE_REASON_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_ADDRCHANGE_REASON_LIKE", "Y");
            }
            parms.put("implAddrchangeReason", example.getImplAddrchangeReason());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_ISRELEASEINFOExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplIsreleaseinfo_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_EQUALS", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_NOT_EQUALS", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_GT", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_GT", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_GE", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_GE", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_LT", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_LT", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_LE", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_LE", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_ISRELEASEINFO_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_ISRELEASEINFO_LIKE", "Y");
            }
            parms.put("implIsreleaseinfo", example.getImplIsreleaseinfo());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_INFO_TITLEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplInfoTitle_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_NULL", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_EQUALS", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_NOT_EQUALS", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_GT", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_GT", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_GE", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_GE", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_LT", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_LT", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_LE", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_LE", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_INFO_TITLE_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_INFO_TITLE_LIKE", "Y");
            }
            parms.put("implInfoTitle", example.getImplInfoTitle());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_RELEASE_MEDIAExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplReleaseMedia_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_NULL", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_EQUALS", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_NOT_EQUALS", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_GT", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_GT", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_GE", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_GE", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_LT", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_LT", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_LE", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_LE", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_RELEASE_MEDIA_LIKE", "Y");
            } else {
                parms.put("AND_IMPL_RELEASE_MEDIA_LIKE", "Y");
            }
            parms.put("implReleaseMedia", example.getImplReleaseMedia());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_JHW_RELEASE_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplJhwReleaseDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_NULL", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_EQUALS", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_NOT_EQUALS", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_GT", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_GT", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_GE", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_GE", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_LT", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_LT", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_JHW_RELEASE_DATE_LE", "Y");
            } else {
                parms.put("AND_IMPL_JHW_RELEASE_DATE_LE", "Y");
            }
            parms.put("implJhwReleaseDate", example.getImplJhwReleaseDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getIMPL_CDC_RELEASE_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getImplCdcReleaseDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_NULL", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_EQUALS", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_NOT_EQUALS", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_GT", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_GT", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_GE", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_GE", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_LT", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_LT", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_IMPL_CDC_RELEASE_DATE_LE", "Y");
            } else {
                parms.put("AND_IMPL_CDC_RELEASE_DATE_LE", "Y");
            }
            parms.put("implCdcReleaseDate", example.getImplCdcReleaseDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getREIM_START_DATEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getReimStartDate_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_NULL", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_NOT_NULL", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_EQUALS", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_NOT_EQUALS", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_GT", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_GT", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_GE", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_GE", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_LT", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_LT", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_START_DATE_LE", "Y");
            } else {
                parms.put("AND_REIM_START_DATE_LE", "Y");
            }
            parms.put("reimStartDate", example.getReimStartDate());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getREIM_RESULTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getReimResult_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_NULL", "Y");
            } else {
                parms.put("AND_REIM_RESULT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_NOT_NULL", "Y");
            } else {
                parms.put("AND_REIM_RESULT_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_RESULT_EQUALS", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_RESULT_NOT_EQUALS", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_GT", "Y");
            } else {
                parms.put("AND_REIM_RESULT_GT", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_GE", "Y");
            } else {
                parms.put("AND_REIM_RESULT_GE", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_LT", "Y");
            } else {
                parms.put("AND_REIM_RESULT_LT", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_LE", "Y");
            } else {
                parms.put("AND_REIM_RESULT_LE", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_RESULT_LIKE", "Y");
            } else {
                parms.put("AND_REIM_RESULT_LIKE", "Y");
            }
            parms.put("reimResult", example.getReimResult());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getREIM_ROLLBACK_REASONExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getReimRollbackReason_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_NULL", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_NOT_NULL", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_EQUALS", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_NOT_EQUALS", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_GT", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_GT", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_GE", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_GE", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_LT", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_LT", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_LE", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_LE", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_ROLLBACK_REASON_LIKE", "Y");
            } else {
                parms.put("AND_REIM_ROLLBACK_REASON_LIKE", "Y");
            }
            parms.put("reimRollbackReason", example.getReimRollbackReason());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getREIM_COSTExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getReimCost_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_NULL", "Y");
            } else {
                parms.put("AND_REIM_COST_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_NOT_NULL", "Y");
            } else {
                parms.put("AND_REIM_COST_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_COST_EQUALS", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_REIM_COST_NOT_EQUALS", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_GT", "Y");
            } else {
                parms.put("AND_REIM_COST_GT", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_GE", "Y");
            } else {
                parms.put("AND_REIM_COST_GE", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_LT", "Y");
            } else {
                parms.put("AND_REIM_COST_LT", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_REIM_COST_LE", "Y");
            } else {
                parms.put("AND_REIM_COST_LE", "Y");
            }
            parms.put("reimCost", example.getReimCost());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getARCH_ISBACKUPExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getArchIsbackup_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_NULL", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_NOT_NULL", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_EQUALS", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_EQUALS", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_NOT_EQUALS", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_GT", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_GT", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_GE", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_GE", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_LT", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_LT", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_LE", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_LE", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_ISBACKUP_LIKE", "Y");
            } else {
                parms.put("AND_ARCH_ISBACKUP_LIKE", "Y");
            }
            parms.put("archIsbackup", example.getArchIsbackup());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getARCH_TYPEExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        switch (example.getArchType_Indicator()) {
        case ViewAllWorkflowInfoExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_NULL", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_NOT_NULL", "Y");
            }
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_EQUALS", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_EQUALS", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_NOT_EQUALS", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_GT", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_GT", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_GE", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_GE", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_LT", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_LT", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_LE", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_LE", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        case ViewAllWorkflowInfoExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ARCH_TYPE_LIKE", "Y");
            } else {
                parms.put("AND_ARCH_TYPE_LIKE", "Y");
            }
            parms.put("archType", example.getArchType());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    private Map getExampleParms(ViewAllWorkflowInfoExample example) {
        Map parms = new HashMap();
        parms.putAll(getORG_CODEExampleParms(example));
        parms.putAll(getMANAGERExampleParms(example));
        parms.putAll(getPLAN_TYPEExampleParms(example));
        parms.putAll(getFISCAL_YEARExampleParms(example));
        parms.putAll(getFUNDS_FROMExampleParms(example));
        parms.putAll(getFUNDS_FIELDExampleParms(example));
        parms.putAll(getACTIVITY_NAMEExampleParms(example));
        parms.putAll(getACTIVITY_LOCATIONExampleParms(example));
        parms.putAll(getBUDGETExampleParms(example));
        parms.putAll(getIDExampleParms(example));
        parms.putAll(getACTIVITY_NOExampleParms(example));
        parms.putAll(getASK_SUBMIT_DATEExampleParms(example));
        parms.putAll(getASK_START_DATEExampleParms(example));
        parms.putAll(getASK_END_DATEExampleParms(example));
        parms.putAll(getASK_ADDRExampleParms(example));
        parms.putAll(getASK_BUDGETExampleParms(example));
        parms.putAll(getASK_RESULTExampleParms(example));
        parms.putAll(getASK_ROLLBACK_COUNTExampleParms(example));
        parms.putAll(getASK_ROLLBACK_REASONExampleParms(example));
        parms.putAll(getASK_LEADEREIM_ISSUING_DATEExampleParms(example));
        parms.putAll(getASK_ISTRAVELExampleParms(example));
        parms.putAll(getASK_TRAVEL_SEND_DATEExampleParms(example));
        parms.putAll(getASK_TRAVEL_ISSUING_DATEExampleParms(example));
        parms.putAll(getSEND_ISPOSTINGExampleParms(example));
        parms.putAll(getSEND_FILE_NAMEExampleParms(example));
        parms.putAll(getSEND_FILE_TYPEExampleParms(example));
        parms.putAll(getSEND_FILE_SEQExampleParms(example));
        parms.putAll(getSEND_SEND_DATEExampleParms(example));
        parms.putAll(getSEND_RESULTExampleParms(example));
        parms.putAll(getSEND_ROLLBACK_COUNTExampleParms(example));
        parms.putAll(getSEND_ROLLBACK_REASONExampleParms(example));
        parms.putAll(getSEND_LEADEREIM_ISSUING_DATEExampleParms(example));
        parms.putAll(getIMPL_START_DATEExampleParms(example));
        parms.putAll(getIMPL_END_DATEExampleParms(example));
        parms.putAll(getIMPL_TIMECHANGE_REASONExampleParms(example));
        parms.putAll(getIMPL_ADDRExampleParms(example));
        parms.putAll(getIMPL_ADDRCHANGE_REASONExampleParms(example));
        parms.putAll(getIMPL_ISRELEASEINFOExampleParms(example));
        parms.putAll(getIMPL_INFO_TITLEExampleParms(example));
        parms.putAll(getIMPL_RELEASE_MEDIAExampleParms(example));
        parms.putAll(getIMPL_JHW_RELEASE_DATEExampleParms(example));
        parms.putAll(getIMPL_CDC_RELEASE_DATEExampleParms(example));
        parms.putAll(getREIM_START_DATEExampleParms(example));
        parms.putAll(getREIM_RESULTExampleParms(example));
        parms.putAll(getREIM_ROLLBACK_REASONExampleParms(example));
        parms.putAll(getREIM_COSTExampleParms(example));
        parms.putAll(getARCH_ISBACKUPExampleParms(example));
        parms.putAll(getARCH_TYPEExampleParms(example));
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public int selectCountByExample(ViewAllWorkflowInfoExample example) {
    	example.setOrgCode_Indicator(ViewAllWorkflowInfoExample.EXAMPLE_EQUALS); 
        BaseUser user = (BaseUser) LoginUtil.getUser();
        String org_Code=user.getOrgCode();
        String orgCode=example.getOrgCode();
        if(orgCode==null||"".equals(orgCode)){
        	example.setOrgCode(org_Code);
        }     	
        Map parms = getExampleParms(example);
        parms.put("AND_ORG_CODE_WITH_SECURITY", "Y"); 
        int count = ((Integer)getSqlMapClientTemplate().queryForObject("view_all_workflow_info.abatorgenerated_selectCountByExample", parms)).intValue();
        return count;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public PageBox selectByExampleWithPaging(ViewAllWorkflowInfoExample example, int pageSize, int pageNum, String orderByClause) {
    	example.setOrgCode_Indicator(ViewAllWorkflowInfoExample.EXAMPLE_EQUALS); 
        BaseUser user = (BaseUser) LoginUtil.getUser();
        String org_Code=user.getOrgCode();
        String orgCode=example.getOrgCode();
        if(orgCode==null||"".equals(orgCode)){
        	example.setOrgCode(org_Code);
        }     	
        Map parms = getExampleParms(example);
        parms.put("AND_ORG_CODE_WITH_SECURITY", "Y"); 
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        PageBox pageBox = new PageBox();
        PageObject pageObject = new PageObject();
        pageObject.setPageSize(pageSize);
        pageObject.setPageIndex(pageNum);
        int itemAmount = selectCountByExample(example);
        pageObject.setItemAmount(itemAmount);
        List pageList = null;
        if (pageObject.getBeginIndex() <= pageObject.getItemAmount()) {
            pageList = (getSqlMapClientTemplate().queryForList("view_all_workflow_info.abatorgenerated_selectByExample", parms, pageObject.getBeginIndex() - 1, pageSize));
        }
        pageBox.setPageObject(pageObject);
        pageBox.setPageList(pageList);
        return pageBox;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public PageBox selectByExampleWithPaging(ViewAllWorkflowInfoExample example, int pageSize, int pageNum) {
        return selectByExampleWithPaging(example, pageSize, pageNum, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table view_all_workflow_info
     *
     * @abatorgenerated Thu Nov 24 16:41:37 CST 2011
     */
    public int updateByPrimaryKeyForCgs(ViewAllWorkflowInfo record) {
        int rows = getSqlMapClientTemplate().update("view_all_workflow_info.abatorgenerated_updateByPrimaryKeyForCgs", record);
        return rows;
    }
}